Implementing Campaign Manager - System Management

Engine DateTime Settings

Engine has two types of DateTime settings: System Wide and User Specific.

System Wide

Settings File Location Project\Config\Engine\Cerberus.ini
Editing Method Engine Configuration applet within AMC
Configuration Values

SystemDateFormat

SystemTimeFormat

SystemDateTimeFormat

For all Date, Time and DateTime data, these system wide settings configure how Engine queries a Date, Time or DateTime column in the repository, they also govern how data is displayed in AMC.

As they are system wide, these settings cannot be changed across databases in the same repository. All databases in the same repository will use the same setting values.

The table below is from the Engine Technical Library and shows all possible DateTime settings in Engine. This is captured at point of writing. Refer to the Engine Technical Library for current information relating to the installed version of Engine.

Setting Name Description Values
SystemDateFormat

Sets the System Date Format.

This is the format in which DATE fields will be used in expressions and queries.

Default = 0

0: CCYYMMDD

1: DDMMCCYY

2: CCYYDDMM

3: MMDDCCYY

4: DDMMYY

5: MMDDYY

6: DDMMMCCYY

SystemDateTimeFormat

Sets the System DateTime format.

This is the format in which DATETIME fields will be used in expressions and queries.

Default = 0

0: CCYYMMDD HHMMSS

01: CCYYMMDD HHMM

02: CCYYMMDD HH:MM:SS

03: CCYYMMDD HH:MM

04: DDMMCCYY HHMMSS

05: DDMMCCYY HHMM

06: DDMMCCYY HH:MM:SS

07: DDMMCCYY HH:MM

08: CCYYDDMM HHMMSS

09: CCYYDDMM HHMM

10: CCYYDDMM HH:MM:SS

11: CCYYDDMM HH:MM

12: MMDDCCYY HHMMSS

13: MMDDCCYY HHMM

14: MMDDCCYY HH:MM:SS

15: MMDDCCYY HH:MM

16: DDMMYY HHMMSS

17: DDMMYY HHMM

18: DDMMYY HH:MM:SS

19: DDMMYY HH:MM

20: MMDDYY HHMMSS

21: MMDDYY HHMM

22: MMDDYY HH:MM:SS

23: MMDDYY HH:MM

24: DDMMMCCYY HHMMSS

25: DDMMMCCYY HHMM

26: DDMMMCCYY HH:MM:SS

27: DDMMMCCYY HH:MM

SytemTimeFormat

Sets the System Time Format.

This is the format in which TIME fields will be used in expressions and queries.

Default = 0

0: HHMMSS

1: HHMM

2: HH:MM:SS

3: HH:MM

User Specific

Settings File Location Project\Config\Engine\Cerberus.ini
Editing Method Add user to Engine via AMC
Configuration Values

DateFormat

TimeFormat

DateTimeFormat

These settings are specific to a single Engine user and are therefore set at a user level. At an Engine level they influence how an Engine user sees Date, Time and DateTime columns.

When using Campaign Manager with Engine, the application has a layer of user configuration for how a user sees Date, Time and DateTime columns so these settings must not be edited.

When a Datasource is configured it will interrogate these settings and persist them up to Campaign Manager.

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice